查询时发生了错误......
select a.InvestAdvisorOutlineID as InvestAdvisorOutlineID,c.enddate as enddate,a.InvestAdvisorOutline001 as InvestAdvisorOutline001,a.count as count,a.categoryid,FundCategoryMaste001 as FundCategoryMaste001,b.size as size,CompanyIntellect001 as CompanyIntellect001,star from (select InvestAdvisorOutlineID,InvestAdvisorOutline001,COUNT(b.secucode) count,b.categoryid from FundSiteDB.dbo.JXN_InvestAdvisorOutline a inner join FundSiteDB.dbo.JXN_FundMain b on a.InvestAdvisorOutlineID=b.FundMain003 where b.CategoryID is not null and FundMain011=1 group by b.CategoryID,InvestAdvisorOutlineID,InvestAdvisorOutline001) as a inner join (select FundMain003,categoryid,SUM(fundsize002) size from FundSiteDB.dbo.JXN_FundSize a,FundSiteDB.dbo.JXN_FundMain b where a.secucode=b.secucode and fundSize001>=(select MAX(enddate) as enddate from FundSiteDB.dbo.JXN_CompanyAbility_Star) group by FundMain003,categoryid) as b on a.InvestAdvisorOutlineID=b.FundMain003 and a.categoryid=b.categoryid inner join FundSiteDB.dbo.JXN_CompanyIntellect c on a.InvestAdvisorOutlineID=c.InvestAdvisorOutlineID and a.categoryid=c.categoryid and cyctype=36 inner join FundSiteDB.dbo.JXN_FundCategoryMaste d on a.CategoryID=d.categoryid and a.InvestAdvisorOutlineID={ inner join (select InvestAdvisorOutlineID,sum(CompanyAbility011_Star)/COUNT(CompanyAbility011_Star) as star from FundSiteDB.dbo.JXN_CompanyAbility_Star where EndDate=(select MAX(enddate) from FundSiteDB.dbo.JXN_ManagerAbility_STAR) and cyctype=36 group by InvestAdvisorOutlineID) as e on a.InvestAdvisorOutlineID=e.InvestAdvisorOutlineID
